SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE [dbo].[usp_AddNewGwyNews]
    (
      @JOL_EmployerName VARCHAR(50),
      @JOL_GWY_NewsTitle VARCHAR(50),
      @JOL_GWY_NewsBody NTEXT,
      @JOL_GWY_ApplyMethod VARCHAR(50),
      @JOL_GWY_NewsClick INT,
      @JOL_GWY_AddUser VARCHAR(50),
      @JOL_GWY_AddTime DATETIME
    )
AS 
    INSERT  INTO dbo.JOL_GWY_News
            (
              JOL_EmployerName,
              JOL_GWY_NewsTitle,
              JOL_GWY_NewsBody,
              JOL_GWY_ApplyMethod,
              JOL_GWY_NewsClick,
              JOL_GWY_AddUser,
              JOL_GWY_AddTime,
              JOL_GWY_UpdateUser,
              JOL_GWY_UpdateTime
            )
    VALUES  (
              @JOL_EmployerName, -- JOL_EmployeeName - varchar(50)
              @JOL_GWY_NewsTitle, -- JOL_GWY_NewsTitle - varchar(100)
              @JOL_GWY_NewsBody, -- JOL_GWY_NewsBody - ntext
              @JOL_GWY_ApplyMethod, -- JOL_GWY_ApplyMethod - varchar(50)
              0, -- JOL_GWY_NewsClick - int
              @JOL_GWY_AddUser, -- JOL_GWY_AddUser - varchar(50)
              GETDATE(), -- JOL_GWY_AddTime - datetime
              NULL, -- JOL_GWY_UpdateUser - varchar(50)
              NULL  -- JOL_GWY_UpdateTime - datetime
            )

GO
